﻿DECLARE @q1 NVARCHAR(MAX)

IF NOT EXISTS(SELECT NULL FROM dbo.Medianamik_MedianamikControl WHERE [MedianamikControlID] =   '5b35035b-4fb7-48dc-b767-5badcb80950d')  
BEGIN
SELECT @q1 = 'INSERT INTO [dbo].[medianamik_MedianamikControl]([MedianamikControlID],[Name],[MaySpecifyWidth],[DefaultWidth],[MaySpecifyHeight],[DefaultHeight],[MaySpecifyLength],[DefaultLength],[CreatedOn],[Type],[FullName],[MaySpecifyValidationExpression],[MayBeRequired],[MayBeUnique],[DataTypeID])
VALUES(''5b35035b-4fb7-48dc-b767-5badcb80950d'',''Telephone TextBox'',1,400,0,null,0,null,''2011-02-28 08:39:15.570'',0,''Medianamik.UI.Controls.TelephoneTextBox, Medianamik.UI'',1,1,0,''195f6f67-f42d-428b-be3e-ad8762cde76f'')
'
EXEC sp_executesql @q1
END

IF NOT EXISTS(SELECT NULL FROM dbo.Medianamik_MedianamikControl WHERE [MedianamikControlID] =   '95ab3a1b-2900-46b5-8f2e-6ddd31e48f2e')  
BEGIN
SELECT @q1 = 'INSERT INTO [dbo].[medianamik_MedianamikControl]([MedianamikControlID],[Name],[MaySpecifyWidth],[DefaultWidth],[MaySpecifyHeight],[DefaultHeight],[MaySpecifyLength],[DefaultLength],[CreatedOn],[Type],[FullName],[MaySpecifyValidationExpression],[MayBeRequired],[MayBeUnique],[DataTypeID])
VALUES(''95ab3a1b-2900-46b5-8f2e-6ddd31e48f2e'',''Code Postal TextBox'',1,400,0,null,0,null,''2011-02-28 08:42:15.570'',0,''Medianamik.UI.Controls.CodePostalTextBox, Medianamik.UI'',1,1,0,''195f6f67-f42d-428b-be3e-ad8762cde76f'')
'
EXEC sp_executesql @q1
END

IF NOT EXISTS(SELECT NULL FROM dbo.Medianamik_MedianamikControl WHERE [MedianamikControlID] =   '89506908-8d9c-49bb-a57e-9379c1871947')  
BEGIN
SELECT @q1 = 'INSERT INTO [dbo].[medianamik_MedianamikControl]([MedianamikControlID],[Name],[MaySpecifyWidth],[DefaultWidth],[MaySpecifyHeight],[DefaultHeight],[MaySpecifyLength],[DefaultLength],[CreatedOn],[Type],[FullName],[MaySpecifyValidationExpression],[MayBeRequired],[MayBeUnique],[DataTypeID])
VALUES(''89506908-8d9c-49bb-a57e-9379c1871947'',''DateTimePicker'',1,300,0,null,0,null,''2011-02-28 08:45:00.570'',0,''Medianamik.UI.Controls.DateTimePicker, Medianamik.UI'',1,1,1,''87cf5a6e-dee6-49ce-a22b-9e69b11e351f'')
'
EXEC sp_executesql @q1
END